from django.db import models


# Create your models here.

class UserType(models.Model):
    name = models.CharField(max_length=32)


class UserInfo(models.Model):
    username = models.CharField(max_length=30)
    pwd = models.CharField(max_length=32)
    email = models.CharField(max_length=32)


class Sales(models.Model):
    dates = models.CharField(db_column='DATES', max_length=50, blank=True, null=True)  # Field name made lowercase.
    goods = models.CharField(db_column='GOODS', max_length=50, blank=True, null=True)  # Field name made lowercase.
    sales = models.CharField(db_column='SALES', max_length=50, blank=True, null=True)  # Field name made lowercase.

    class Meta:
        db_table = 'SALES'
